package org.jeecg.modules.fw.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.jeecg.modules.fw.entity.FwRoomExamine;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;

/**
 * @Description: fw_room_examine
 * @Author: jeecg-boot
 * @Date:   2023-05-23
 * @Version: V1.0
 */
public interface FwRoomExamineMapper extends BaseMapper<FwRoomExamine> {

    @Select("select fre.room_id from fw_room_examine fre " +
            "inner join bus_rooms_living_order brlo on brlo.id = fre.living_order_id " +
            "where brlo.settle_type = -1 and (fre.state = 1 or fre.state = 2) and fre.hotel_id = #{hotelId}")
    List<String> getExamineRoom(String hotelId);
}
